| |
46 Search Results Found |
| 1 |
Forum: Business Intelligence «»
Posted on: Sat, 23 May 2020 03:12 «»
By: oluranti
Re:Invalid Service name in RCU installation for OBIEE 12c
…Hi,
I want to install OBIEE 12c and practice with it on my laptop. I have successfully installed the following:
Oracle Database 12c (I have done the data configuration installation)
Weblogic
BI plaform
but got stuck on RCU step 3 of 8 (picture …
|
| 2 |
Forum: Marketplace «»
Posted on: Tue, 20 March 2018 05:45 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
New version (2018.03.20) with the following modifications:
Fix bugs in ALTER/MODIFY command introduced in previous version with the "step/ABORT_STEP" option
GRANTS parameter of USER command now support "+" as delimiter in addition …
|
| 3 |
Forum: Weblogic & Application Server «»
Posted on: Mon, 05 December 2016 04:34 «»
By: calacausi
Oracle App. Server 10g. error when accessing file on a remote server
…hi,
i need my Forms application access files stored in a remote server. I checked that \\OASServer and \\RemoteServer computers are in the same domain, and the remote directory \\RemoteServer\temp is shared and has full control rights assigned to '…
|
| 4 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:14 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
DDL command
In the same vein than the previous command, CONTENT, McDP allows you to get the DDL of all or part of a database, with the transformation you want, using the DDL command.
Its syntax is:
McDP [<logon>] { -ddl | --ddl } [<…
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 17 May 2016 09:32 «»
By: mjm22
MEMBER OF condition across DB Link
…Hi,
I have come across a scenario that I am struggling to understand...
I am trying to insert to a table a subset of values selected form another table on a remote database. The selection is controlled via a MEMBER OF condition that limits the …
|
| 6 |
Forum: Windows «»
Posted on: Wed, 06 May 2015 23:16 «»
By: dark_prince
Re: How to Insert / Retrieve data in Marathi / Hindi font
…guys. I drop the database. And now for creating new database I found script, I thought before running it i should show that to you guys.
REM ASSUMPTIONS
rem oracle xe has been installed
rem oracle_home has been set
rem oracle_sid has been set
…
|
| 7 |
Forum: Server Administration «»
Posted on: Thu, 28 August 2014 14:17 «»
By: dstolf
Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c
…is a though one, with many variables, so bear with me.
I have created two databases using Oracle dNFS clone. The backup image is stored on ASM and both clones are stored on NFS and use the same backup image. It's a plain simple single instance …
|
| 8 |
Forum: Performance Tuning «»
Posted on: Thu, 17 October 2013 09:57 «»
By: hesaigo999ca
Re: Help with 12c vs 10.2g
…all for being patient and lots of suggestions...
Here so far is extra info as well as the progress I have made so far.
Info...
Roachcoach:I do know what the jobs are doing, the sql is the same in both cases, hence why I consider this to be simple and…
|
| 9 |
Forum: Server Administration «»
Posted on: Mon, 30 September 2013 00:33 «»
By: ishika_20
ORA-30967: operation directly on the Path Table (during CSSCAN process)
…All,
While doing scanning of character set, error occurred in between.
Kindly assist me to solve the problem.
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application …
|
| 10 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 10 September 2012 07:16 «»
By: kashifchughtai
Re: selecting clob value over dblink
…cannot do any change on remote database. i read on a blog tht it is possible using the global temp table.
something like given below:
create global temporary table LocalTempTableWithClob
(myid number, myclob clob) ON COMMIT PRESERVE ROWS;
…
|
| 11 |
Forum: Backup & Recovery «»
Posted on: Tue, 31 July 2012 14:37 «»
By: drumboy
Re: Flash Recovery ->SYSTEM.DBF
…Jul 31 19:01:57 2012
Starting ORACLE instance (normal)
Tue Jul 31 19:02:20 2012
alter database open resetlogs
ORA-1194 signalled during: alter database open resetlogs...
Tue Jul 31 20:38:30 2012
Shutting down instance (immediate)
Shutting down …
|
| 12 |
Forum: Windows «»
Posted on: Wed, 28 March 2012 02:36 «»
By: ranamirfan
Re: Unable to install oracle 11gR2 on Windows 7 Professional.
…file.
[main] [ 2012-03-28 10:23:38.047 AST ] [HAUtils.getHASHome:631] Oracle home from system properties: C:\oracle11g\hoitdevweb3\product\11.2.0\dbhome_1
[main] [ 2012-03-28 10:23:38.047 AST ] [HAUtils.getCRSHome:588] Getting configured CRS/HAS …
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 11 February 2012 02:04 «»
By: aallan
Re: Create HTML table problem in email
…Michel for reply,
this is my code:
Create Or Replace Procedure Sale.Html_Email_With_Attach(
P_To In Varchar2,
P_Cc In Varchar2 Default Null,
P_Bcc In Varchar2 Default Null,
P_From In …
|
| 14 |
Forum: Networking and Gateways «»
Posted on: Wed, 25 January 2012 21:31 «»
By: reym21
dblinks
…day!
Please help me to connect Oracle 10g (connecting dB) to Oracle 7.3.4 (remote dB) via dblink (both in DEV environment). I encounter these errors everytime I attempted to, re:
ORA-12545: Connect failed because target host or object does not exist…
|
| 15 |
Forum: Linux «»
Posted on: Sat, 24 September 2011 14:56 «»
By: JiXO
Re: Enterprise Manager error
…is the content of alert_orcl.log
Thu Sep 22 17:17:33 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using …
|
| 16 |
Forum: Server Utilities «»
Posted on: Tue, 02 August 2011 05:28 «»
By: dkdms2124
Re: Clone Database user
…I run the Batch file, I got below mentioned error:
--------------------------------------------------------------------------------
Create a new schema/user like an existing schema/user.
Defaults are shown between brackets…
|
| 17 |
Forum: Business Intelligence «»
Posted on: Fri, 31 December 2010 00:20 «»
By: swapna053
Re: not able to install obiee completely
…Hello,
RCU issue i resolved now the error occurs only in configuration Step.
Its runs for an hour and shows failed at end Step 11.Create domain step.
In the log i am getting this error.
The Inventory log i checked at C:\Program Files\Oracle\…
|
| 18 |
Forum: Backup & Recovery «»
Posted on: Tue, 28 September 2010 10:10 «»
By: sojus
Re: reinstall oracle server using existing d:\oracle\product,,
…to explain my situation, i was asked by someone who accidently changed the partiton table on a db server to get back their data. after doing this the next question was to reinstall the db server...
regarding the install:
version/os: oracle 10.2.0.4 …
|
| 19 |
Forum: Enterprise Manager «»
Posted on: Mon, 06 September 2010 09:07 «»
By: dbanukesh
OEM11g Management Agent deploy errors on Oracle 10g R2 4 node RAC
…All,
I have been facing issues deplyong OEM 11g agent on Oracle 10g Target databases. I have installed OEM Agent 11g which is functioning perfectly. Now i am trying to deploy management agent 11g on Target databases which are a Oracle 10g RAC system …
|
| 20 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Tue, 17 August 2010 15:49 «»
By: davholla
Re: Install Oracle E-Business Suite new error
…is the log file
Oracle Applications Rapid Install Wizard Install log
>> Using Rapid Wizard Version : 12.1.1.9
>> Install session started : Tue Aug 17 21:41:47 BST 2010
>> Rapid Wizard source location : /tmp/…
|
| 21 |
Forum: Server Administration «»
Posted on: Thu, 15 July 2010 00:00 «»
By: maniatniit
Re: ORA-00214:
…file d:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Wed Jun 09 17:19:45 2010
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : …
|
| 22 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 02 January 2010 23:07 «»
By: patjose
Re: Parallel DML is not working.
…mount point is on EMC Clarion Disk Array and RAID Type is RAID1/0. So lun is mirrored and striped. This particular lun has around 60 disks each with 73GB. So undo, redo files, temp and datafiles are on this lun and hence on the same mount point.
…
|
| 23 |
Forum: Linux «»
Posted on: Fri, 03 July 2009 06:04 «»
By: dragos
Installing 11g Enterprise on Ubuntu Server 8.04 LTS 64 bit
…Hello,
I am having troubles installing Oracle 11g Enterprise on our new server.
I installed a fresh Ubuntu Server 8.04 LTS then applied xorg and gnome desktop(users work remote on the system using NX).
Now I am trying to install Oracle, I have …
|
| 24 |
Forum: Weblogic & Application Server «»
Posted on: Mon, 23 February 2009 10:55 «»
By: agarrigues
Re: Error FRM-41838 when running forms
…got the same error message
which was solved by changing default TEMP directories
used in different xml config files :
Oracle IAS was installed using a Microsoft Remote Desktop
and the TEMP environment variable that points to a temporary directory that…
|
| 25 |
Forum: Server Administration «»
Posted on: Fri, 29 August 2008 22:40 «»
By: BlackSwan
Re: ORA-01652, ORA-02063
…http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above
02063, 00000, "preceding %s%s from %s%s"
// *Cause: an Oracle error was received from a remote database link.
// *Action: refer…
|
| 26 |
Forum: Server Administration «»
Posted on: Fri, 29 August 2008 22:33 «»
By: suiren97
ORA-01652, ORA-02063
…error shows in alert log.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-02063: preceding line from ABC
Query select using dblink. The uable to extend temp segment is occur in local db (9i) or the remote db (10g)?
Kindly …
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 28 May 2008 01:27 «»
By: sdhanuka
Re: Tablespace monitoring
…the spooling report code is
set arraysize 1
set heading on
set feedback off
set verify off
set linesize 150
set pages 9999
set echo off
set term off feed off trimspool on RECSEP off
set markup html on spool on entmap off preformat off
…
|
| 28 |
Forum: Performance Tuning «»
Posted on: Thu, 13 March 2008 11:34 «»
By: faiz_hyd
Waits During Inserts .
…Hi,
We are seeing some waits for this insert Statement.
This table and Blob is in a different Tablespace seperated from rest of table/Indexes of the APP.
All these below waits were for 10-60 secs time, This is a Image table where we store images, …
|
| 29 |
Forum: Performance Tuning «»
Posted on: Mon, 01 October 2007 15:43 «»
By: Frank Naude
Re: Tuning query (insert using select)
I would load the remote tables into local temp tables first, then join them.
Also, consider creating indexes on the local temp tables before the final join phase.
|
| 30 |
Forum: Server Administration «»
Posted on: Wed, 13 December 2006 03:27 «»
By: gsgill76
ORA-04052: error occurred when looking up remote object REPADMIN.SYS@DB
…Hi, Basically I want to setup Replication between two servers, 'ZEN2K7' & 'DB' (Advanced master-to-master replication, Sync).
This is what i had done so far.
At Server 'ZEN2K7'
CONNECT system/manager@ZEN2K7
CREATE USER repadmin IDENTIFIED BY …
|
| 31 |
Forum: Networking and Gateways «»
Posted on: Mon, 15 May 2006 15:26 «»
By: nmacdannald
Re: Application Connection Error
…links.
Okay, here is the deal. I just spent two days reading about something that a person can explain in two minutes.
1) Make sure your tnsnames.ora have the same correct entries on both local and remote databases.
then lsnrctl reload
2) …
|
| 32 |
Forum: Networking and Gateways «»
Posted on: Mon, 20 March 2006 17:28 «»
By: nmacdannald
How to create a database link
…links.
Okay, here is the deal. I just spent two days reading about something that a person can explain in two minutes.
Make sure your tnsnames.ora have the same correct entries.
then lsnrctl reload
create a public database link on the local …
|
| 33 |
Forum: Training & Certification «»
Posted on: Sat, 21 May 2005 00:36 «»
By: reshma_1226
Re: Urgent- Need Some DBA Interview Questions
…AULT’S INTERVIEW QUESTIONS FOR ORACLE, DBA, DEVELOPER CANDIDATES
Score each question on a 1-5 or 1-10 scale.
DBA SECTIONS: SQL/SQLPLUS, PL/SQL, TUNING, CONFIGURATION, TROUBLE SHOOTING
DEVELOPER SECTIONS: SQL/SQLPLUS, PL/SQL, DATA MODELING
DATA …
|
| 34 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 11 March 2005 03:08 «»
By: Ken Jones
Re: Cursor Loop
…Todd, thanks!! The reason I am crating this script is that the siebel application user wants it creating due to users being deleted etc in the past. This was, he has a create user script for each node stored on the server.
CREATE OR REPLACE PROCEDURE …
|
| 35 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 24 February 2005 13:49 «»
By: Todd Barry
Re: Cursor Loop
…is not tested, but it seems you would want something like (exception handling not shown):
declare
v_rc sys_refcursor;
v_user dba_users%rowtype;
begin
for rec_node in (select node_tns from orcladmin.node_tns) loop
open v_rc for '…
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 14 December 2004 21:32 «»
By: saritha
Most FAQ,s in pl/sql during the interview's
…question bank
Oracle 7 Concepts and Architecture Database Structures.
1. What are the components of Physical database structure of Oracle Database?.
ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log fi…
|
| 37 |
Forum: Replication «»
Posted on: Tue, 02 November 2004 03:37 «»
By: vx
Materialized Views
…<DIV id=intelliTxt style="PADDING-RIGHT: 5px; PADDING-LEFT: 5px">Hi Guys
Im having problems setting up Oracle Replication. Im trying to add a Master Site and a Materialized view from a site. Can some one PLEAAAAAAAASE help me. Im using o…
|
| 38 |
Forum: Training & Certification «»
Posted on: Thu, 02 October 2003 06:10 «»
By: Shaik Anees
Re: In Need Urgent Interview Questions(SQL, PL/SQL, SQL Plus, Developer)
…INTERVIEW QUESTIONS
1.What are the various types of Exceptions ?
User defined and Predefined Exceptions.
2.Can we define exceptions twice in same block ?
No.
3.What is the difference between a procedure and a function ?
Functions return a single variable…
|
| 39 |
Forum: Training & Certification «»
Posted on: Tue, 17 June 2003 04:39 «»
By: Interview
Re: Interview Questions(SQL, PL/SQL, SQL Plus, Developer, Database, anything dealing with Oracle)
…it out again..
GENERAL INTERVIEW QUESTIONS
1.What are the various types of Exceptions ?
User defined and Predefined Exceptions.
2.Can we define exceptions twice in same block ?
No.
3.What is the difference between a procedure and a function ?
Functions …
|
| 40 |
Forum: Other Operating Systems «»
Posted on: Sat, 03 May 2003 19:28 «»
By: Gia McNerney
Re: COBOL precompile jcl
…: Here's one that works - its a bit verbose as its split into proc and parms etc
: //CFCICS1X JOB CFCICS1,
: // 'OLXDSQLC/OSAMPLE2',
: // CLASS=C,NOTIFY=CFCICS1,REGION=6M,
: // MSGCLASS=X,MSGLEVEL=(1,1)
: // JCLLIB ORDER=(CFSYSP.XYZ.PROCLIB)
: //* TH…
|
Blog
Search
Help
Members
Register
Login
Home